Improving Cloud Availability with On-the-fly Schema Updates

Database applications undergo frequent schema changes. To change the schema, the application has to be shut down and migrated to the new version, or run in a mixed mode that supports old and new clients, e.g., via schema versioning. Shutdowns are problematic for applications that cannot tolerate downtime such as embedded, real-time or missioncritical systems; in the Cloud, shutdowns can lead to Service Level Agreement violations or worse, to service interruptions for critical platforms such as healthcare. Mixed-mode operation raises programmability, consistency and performance degradation issues. In this paper we present a system that exploits the march-forward nature of many database applications (no need to support old schema versions after the schema update) to provide on-the-fly updates while ensuring consistency, and being transparent to clients. We first study schema evolution and database usage based on longitudinal studies of four popular open source applications. Next, we implement support for safe on-the-fly schema updates on top of the popular SQLite database engine. Finally, we evaluate our approach using real-world schema changes and database usage scenarios for applications running in the Cloud on the Amazon Web Services platform, and on server systems. We show how on-the-fly schema updates can increase Cloud applications’ availability from less than two nines (99%) to more than six nines (99.9999%). More generally, our experiments indicate that SQLite-based applications can enjoy fully automatic on-the-fly schema updates at a low, transient overhead. Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. To copy otherwise, to republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. The 19th International Conference on Management of Data (COMAD), 19th-21st Dec, 2013 at Ahmedabad, India. Copyright c ©2013 Computer Society of India (CSI).